{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# OpenDataTools 支持开放式基金数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 导入fund接口\n",
    "from opendatatools import fund\n",
    "\n",
    "# 注：数据来源 - 东方财富网"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>companyid</th>\n",
       "      <th>companyname</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>80000080</td>\n",
       "      <td>山西证券</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>80000095</td>\n",
       "      <td>国都证券</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>80000200</td>\n",
       "      <td>中银国际证券</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>80000220</td>\n",
       "      <td>南方基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>80000221</td>\n",
       "      <td>富国基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>80000222</td>\n",
       "      <td>华夏基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>80000223</td>\n",
       "      <td>嘉实基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>80000224</td>\n",
       "      <td>国泰基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>80000225</td>\n",
       "      <td>大成基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>80000226</td>\n",
       "      <td>博时基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>80000227</td>\n",
       "      <td>长盛基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>80000228</td>\n",
       "      <td>华安基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>80000229</td>\n",
       "      <td>易方达基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>80000230</td>\n",
       "      <td>鹏华基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>80000231</td>\n",
       "      <td>融通基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>80000233</td>\n",
       "      <td>国投瑞银基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>80000235</td>\n",
       "      <td>银华基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>80000236</td>\n",
       "      <td>宝盈基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>80000237</td>\n",
       "      <td>银河基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>80000238</td>\n",
       "      <td>泰达宏利基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>80000239</td>\n",
       "      <td>长城基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>80000240</td>\n",
       "      <td>万家基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>80000243</td>\n",
       "      <td>长信基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>80000245</td>\n",
       "      <td>金鹰基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>80000246</td>\n",
       "      <td>海富通基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>80000247</td>\n",
       "      <td>泰信基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>80000248</td>\n",
       "      <td>广发基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>80000249</td>\n",
       "      <td>新华基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>80000250</td>\n",
       "      <td>华宝基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>80000251</td>\n",
       "      <td>景顺长城基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>80380794</td>\n",
       "      <td>创金合信基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>80384640</td>\n",
       "      <td>九泰基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>80385906</td>\n",
       "      <td>红土创新基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>80391977</td>\n",
       "      <td>华泰证券(上海)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>80403111</td>\n",
       "      <td>浙商证券资管</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>80404004</td>\n",
       "      <td>长江证券(上海)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>80404701</td>\n",
       "      <td>财通资管</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>80424273</td>\n",
       "      <td>泓德基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>80446423</td>\n",
       "      <td>金信基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>80452130</td>\n",
       "      <td>新沃基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>80455765</td>\n",
       "      <td>中科沃土基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>80468996</td>\n",
       "      <td>前海联合</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>80488954</td>\n",
       "      <td>富荣基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>80498278</td>\n",
       "      <td>汇安基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>80501166</td>\n",
       "      <td>先锋基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>80508384</td>\n",
       "      <td>恒生前海基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>80508391</td>\n",
       "      <td>中航基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>80522693</td>\n",
       "      <td>鹏扬基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>80523667</td>\n",
       "      <td>华泰保兴</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>80538609</td>\n",
       "      <td>渤海汇金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>80548351</td>\n",
       "      <td>格林基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>80555446</td>\n",
       "      <td>南华基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>80560379</td>\n",
       "      <td>弘毅远方基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>80560380</td>\n",
       "      <td>恒越基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>80560381</td>\n",
       "      <td>凯石基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>80560388</td>\n",
       "      <td>东方阿尔法基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>80560389</td>\n",
       "      <td>国融基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>80560392</td>\n",
       "      <td>博道基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>80560393</td>\n",
       "      <td>华融基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>80560396</td>\n",
       "      <td>青松基金</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>131 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    companyid companyname\n",
       "90   80000080        山西证券\n",
       "30   80000095        国都证券\n",
       "126  80000200      中银国际证券\n",
       "77   80000220        南方基金\n",
       "22   80000221        富国基金\n",
       "45   80000222        华夏基金\n",
       "61   80000223        嘉实基金\n",
       "26   80000224        国泰基金\n",
       "15   80000225        大成基金\n",
       "3    80000226        博时基金\n",
       "6    80000227        长盛基金\n",
       "50   80000228        华安基金\n",
       "111  80000229       易方达基金\n",
       "79   80000230        鹏华基金\n",
       "86   80000231        融通基金\n",
       "27   80000233      国投瑞银基金\n",
       "109  80000235        银华基金\n",
       "5    80000236        宝盈基金\n",
       "115  80000237        银河基金\n",
       "98   80000238      泰达宏利基金\n",
       "13   80000239        长城基金\n",
       "99   80000240        万家基金\n",
       "12   80000243        长信基金\n",
       "69   80000245        金鹰基金\n",
       "40   80000246       海富通基金\n",
       "97   80000247        泰信基金\n",
       "31   80000248        广发基金\n",
       "108  80000249        新华基金\n",
       "51   80000250        华宝基金\n",
       "64   80000251      景顺长城基金\n",
       "..        ...         ...\n",
       "10   80380794      创金合信基金\n",
       "68   80384640        九泰基金\n",
       "53   80385906      红土创新基金\n",
       "44   80391977    华泰证券(上海)\n",
       "117  80403111      浙商证券资管\n",
       "11   80404004    长江证券(上海)\n",
       "9    80404701        财通资管\n",
       "48   80424273        泓德基金\n",
       "67   80446423        金信基金\n",
       "107  80452130        新沃基金\n",
       "128  80455765      中科沃土基金\n",
       "85   80468996        前海联合\n",
       "23   80488954        富荣基金\n",
       "56   80498278        汇安基金\n",
       "105  80501166        先锋基金\n",
       "57   80508384      恒生前海基金\n",
       "129  80508391        中航基金\n",
       "80   80522693        鹏扬基金\n",
       "55   80523667        华泰保兴\n",
       "2    80538609        渤海汇金\n",
       "36   80548351        格林基金\n",
       "76   80555446        南华基金\n",
       "59   80560379      弘毅远方基金\n",
       "58   80560380        恒越基金\n",
       "71   80560381        凯石基金\n",
       "14   80560388     东方阿尔法基金\n",
       "35   80560389        国融基金\n",
       "1    80560392        博道基金\n",
       "60   80560393        华融基金\n",
       "84   80560396        青松基金\n",
       "\n",
       "[131 rows x 2 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 获取基金公司列表\n",
    "df, msg = fund.get_fund_company()\n",
    "df.sort_values('companyid', inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>fundcode</th>\n",
       "      <th>fundname</th>\n",
       "      <th>pingyin</th>\n",
       "      <th>nav</th>\n",
       "      <th>accu_nav</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>000001</td>\n",
       "      <td>华夏成长</td>\n",
       "      <td>HXCZ</td>\n",
       "      <td>1.1010</td>\n",
       "      <td>3.5120</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000011</td>\n",
       "      <td>华夏大盘精选</td>\n",
       "      <td>HXDPJX</td>\n",
       "      <td>13.9360</td>\n",
       "      <td>18.1160</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>000014</td>\n",
       "      <td>华夏聚利债券</td>\n",
       "      <td>HXJLZQ</td>\n",
       "      <td>1.1230</td>\n",
       "      <td>1.1230</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>000015</td>\n",
       "      <td>华夏纯债债券A</td>\n",
       "      <td>HXCZZQA</td>\n",
       "      <td>1.1990</td>\n",
       "      <td>1.2290</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>000016</td>\n",
       "      <td>华夏纯债债券C</td>\n",
       "      <td>HXCZZQC</td>\n",
       "      <td>1.1730</td>\n",
       "      <td>1.2030</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>000021</td>\n",
       "      <td>华夏优势增长混合</td>\n",
       "      <td>HXYSZZHH</td>\n",
       "      <td>1.6180</td>\n",
       "      <td>2.7880</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>000031</td>\n",
       "      <td>华夏复兴混合</td>\n",
       "      <td>HXFXHH</td>\n",
       "      <td>1.4960</td>\n",
       "      <td>1.4960</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>000041</td>\n",
       "      <td>华夏全球精选</td>\n",
       "      <td>HXQQJX</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>000047</td>\n",
       "      <td>华夏双债增强债券A</td>\n",
       "      <td>HXSZZQZQA</td>\n",
       "      <td>1.1540</td>\n",
       "      <td>1.3740</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>000048</td>\n",
       "      <td>华夏双债增强债券C</td>\n",
       "      <td>HXSZZQZQC</td>\n",
       "      <td>1.1420</td>\n",
       "      <td>1.3570</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>000051</td>\n",
       "      <td>华夏沪深300ETF联接A</td>\n",
       "      <td>HXHS300ETFLJA</td>\n",
       "      <td>1.2230</td>\n",
       "      <td>1.2230</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>000061</td>\n",
       "      <td>华夏盛世混合</td>\n",
       "      <td>HXSSHH</td>\n",
       "      <td>0.7250</td>\n",
       "      <td>0.7250</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>000071</td>\n",
       "      <td>华夏恒生ETF联接</td>\n",
       "      <td>HXHSETFLJ</td>\n",
       "      <td>1.5294</td>\n",
       "      <td>1.5294</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>000075</td>\n",
       "      <td>华夏恒生联接现汇</td>\n",
       "      <td>HXHSLJXH</td>\n",
       "      <td>0.2378</td>\n",
       "      <td>0.2378</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>000121</td>\n",
       "      <td>华夏永福混合A</td>\n",
       "      <td>HXYFHHA</td>\n",
       "      <td>1.5970</td>\n",
       "      <td>1.5970</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>000945</td>\n",
       "      <td>华夏医疗健康混合A</td>\n",
       "      <td>HXYLJKHHA</td>\n",
       "      <td>1.6010</td>\n",
       "      <td>1.6010</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>000946</td>\n",
       "      <td>华夏医疗健康混合C</td>\n",
       "      <td>HXYLJKHHC</td>\n",
       "      <td>1.5740</td>\n",
       "      <td>1.5740</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>000948</td>\n",
       "      <td>华夏沪港通恒生ETF联接A</td>\n",
       "      <td>HXHGTHSETFLJA</td>\n",
       "      <td>1.2664</td>\n",
       "      <td>1.2664</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>000975</td>\n",
       "      <td>MSCI中国A股ETF联接A</td>\n",
       "      <td>MSCIZGAGETFLJA</td>\n",
       "      <td>1.04</td>\n",
       "      <td>1.04</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>001001</td>\n",
       "      <td>华夏债券A/B</td>\n",
       "      <td>HXZQA/B</td>\n",
       "      <td>1.0420</td>\n",
       "      <td>1.8720</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>001003</td>\n",
       "      <td>华夏债券C</td>\n",
       "      <td>HXZQC</td>\n",
       "      <td>1.0350</td>\n",
       "      <td>1.8250</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>001011</td>\n",
       "      <td>华夏希望债券A</td>\n",
       "      <td>HXXWZQA</td>\n",
       "      <td>1.1060</td>\n",
       "      <td>1.6260</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>001013</td>\n",
       "      <td>华夏希望债券C</td>\n",
       "      <td>HXXWZQC</td>\n",
       "      <td>1.0890</td>\n",
       "      <td>1.5890</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>001015</td>\n",
       "      <td>华夏沪深300指数增强A</td>\n",
       "      <td>HXHS300ZSZQA</td>\n",
       "      <td>1.3480</td>\n",
       "      <td>1.3480</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>001016</td>\n",
       "      <td>华夏沪深300指数增强C</td>\n",
       "      <td>HXHS300ZSZQC</td>\n",
       "      <td>1.3260</td>\n",
       "      <td>1.3260</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>001021</td>\n",
       "      <td>华夏亚债中国指数A</td>\n",
       "      <td>HXYZZGZSA</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1.2650</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>001023</td>\n",
       "      <td>华夏亚债中国指数C</td>\n",
       "      <td>HXYZZGZSC</td>\n",
       "      <td>1.13</td>\n",
       "      <td>1.2350</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>001031</td>\n",
       "      <td>华夏安康优选债券A</td>\n",
       "      <td>HXAKYXZQA</td>\n",
       "      <td>1.2640</td>\n",
       "      <td>1.4240</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>001033</td>\n",
       "      <td>华夏安康优选债券C</td>\n",
       "      <td>HXAKYXZQC</td>\n",
       "      <td>1.24</td>\n",
       "      <td>1.40</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>001042</td>\n",
       "      <td>华夏领先股票</td>\n",
       "      <td>HXLXGP</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.56</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>005177</td>\n",
       "      <td>华夏睿磐泰利定开混合A</td>\n",
       "      <td>HXRPTLDKHHA</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.99</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>005178</td>\n",
       "      <td>华夏睿磐泰利定开混合C</td>\n",
       "      <td>HXRPTLDKHHC</td>\n",
       "      <td>0.9886</td>\n",
       "      <td>0.9886</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>005213</td>\n",
       "      <td>华夏鼎旺三个月定开债A</td>\n",
       "      <td>HXDWSGYDKZA</td>\n",
       "      <td>1.0136</td>\n",
       "      <td>1.0136</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>005214</td>\n",
       "      <td>华夏鼎旺三个月定开债C</td>\n",
       "      <td>HXDWSGYDKZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>005218</td>\n",
       "      <td>华夏聚惠(FOF)A</td>\n",
       "      <td>HXJHFOFA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>005219</td>\n",
       "      <td>华夏聚惠(FOF)C</td>\n",
       "      <td>HXJHFOFC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>005407</td>\n",
       "      <td>华夏鼎泰六个月定开债A</td>\n",
       "      <td>HXDTLGYDKZA</td>\n",
       "      <td>1.0013</td>\n",
       "      <td>1.0013</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>005408</td>\n",
       "      <td>华夏鼎泰六个月定开债C</td>\n",
       "      <td>HXDTLGYDKZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>005449</td>\n",
       "      <td>华夏行业龙头混合</td>\n",
       "      <td>HXHYLTHH</td>\n",
       "      <td>1.0269</td>\n",
       "      <td>1.0269</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>005450</td>\n",
       "      <td>华夏稳盛灵活配置混合</td>\n",
       "      <td>HXWSLHPZHH</td>\n",
       "      <td>1.0236</td>\n",
       "      <td>1.0236</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>005534</td>\n",
       "      <td>华夏新时代混合(QDII)</td>\n",
       "      <td>HXXSDHHQDII</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>005581</td>\n",
       "      <td>华夏信用债ETF联接A</td>\n",
       "      <td>HXXYZETFLJA</td>\n",
       "      <td>1.0148</td>\n",
       "      <td>1.0148</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>005582</td>\n",
       "      <td>华夏信用债ETF联接C</td>\n",
       "      <td>HXXYZETFLJC</td>\n",
       "      <td>1.0145</td>\n",
       "      <td>1.0145</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>005658</td>\n",
       "      <td>华夏沪深300ETF联接C</td>\n",
       "      <td>HXHS300ETFLJC</td>\n",
       "      <td>1.2210</td>\n",
       "      <td>1.2210</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>005698</td>\n",
       "      <td>华夏全球科技先锋混合</td>\n",
       "      <td>HXQQKJXFHH</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>005733</td>\n",
       "      <td>华夏上证50ETF联接C</td>\n",
       "      <td>HXSZ50ETFLJC</td>\n",
       "      <td>0.9050</td>\n",
       "      <td>0.9050</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>005734</td>\n",
       "      <td>华夏沪港通恒生ETF联接C</td>\n",
       "      <td>HXHGTHSETFLJC</td>\n",
       "      <td>1.2659</td>\n",
       "      <td>1.2659</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>005735</td>\n",
       "      <td>MSCI中国A股ETF联接C</td>\n",
       "      <td>MSCIZGAGETFLJC</td>\n",
       "      <td>1.0390</td>\n",
       "      <td>1.0390</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>160311</td>\n",
       "      <td>华夏蓝筹</td>\n",
       "      <td>HXLC</td>\n",
       "      <td>1.4920</td>\n",
       "      <td>4.9830</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>160314</td>\n",
       "      <td>华夏行业混合(LOF)</td>\n",
       "      <td>HXHYHHLOF</td>\n",
       "      <td>1.0180</td>\n",
       "      <td>6.14</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>160322</td>\n",
       "      <td>华夏港股通精选股票LOF</td>\n",
       "      <td>HXGGTJXGPLOF</td>\n",
       "      <td>1.2228</td>\n",
       "      <td>1.2728</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>160323</td>\n",
       "      <td>华夏磐泰定开混合(LOF)</td>\n",
       "      <td>HXPTDKHHLOF</td>\n",
       "      <td>1.0115</td>\n",
       "      <td>1.0115</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>160324</td>\n",
       "      <td>华夏磐晟定开混合(LOF)</td>\n",
       "      <td>HXPSDKHHLOF</td>\n",
       "      <td>0.9447</td>\n",
       "      <td>0.9447</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>288001</td>\n",
       "      <td>华夏经典混合</td>\n",
       "      <td>HXJDHH</td>\n",
       "      <td>1.0410</td>\n",
       "      <td>3.4310</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>288002</td>\n",
       "      <td>华夏收入混合</td>\n",
       "      <td>HXSRHH</td>\n",
       "      <td>4.6180</td>\n",
       "      <td>6.0180</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>288102</td>\n",
       "      <td>华夏稳定双利债券C</td>\n",
       "      <td>HXWDSLZQC</td>\n",
       "      <td>1.0523</td>\n",
       "      <td>1.8594</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>501050</td>\n",
       "      <td>华夏上证50AH优选指数</td>\n",
       "      <td>HXSZ50AHYXZS</td>\n",
       "      <td>1.1730</td>\n",
       "      <td>1.1730</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>519029</td>\n",
       "      <td>华夏平稳增长</td>\n",
       "      <td>HXPWZZ</td>\n",
       "      <td>1.5310</td>\n",
       "      <td>2.3360</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>519908</td>\n",
       "      <td>华夏兴华混合A</td>\n",
       "      <td>HXXHHHA</td>\n",
       "      <td>1.6120</td>\n",
       "      <td>6.0310</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>519918</td>\n",
       "      <td>华夏兴和混合</td>\n",
       "      <td>HXXHHH</td>\n",
       "      <td>1.4850</td>\n",
       "      <td>3.8070</td>\n",
       "      <td>2018-06-15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>153 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    fundcode        fundname         pingyin      nav accu_nav        date\n",
       "48    000001            华夏成长            HXCZ   1.1010   3.5120  2018-06-15\n",
       "0     000011          华夏大盘精选          HXDPJX  13.9360  18.1160  2018-06-15\n",
       "42    000014          华夏聚利债券          HXJLZQ   1.1230   1.1230  2018-06-15\n",
       "31    000015         华夏纯债债券A         HXCZZQA   1.1990   1.2290  2018-06-15\n",
       "32    000016         华夏纯债债券C         HXCZZQC   1.1730   1.2030  2018-06-15\n",
       "7     000021        华夏优势增长混合        HXYSZZHH   1.6180   2.7880  2018-06-15\n",
       "15    000031          华夏复兴混合          HXFXHH   1.4960   1.4960  2018-06-15\n",
       "124   000041          华夏全球精选          HXQQJX                    2018-06-15\n",
       "35    000047       华夏双债增强债券A       HXSZZQZQA   1.1540   1.3740  2018-06-15\n",
       "37    000048       华夏双债增强债券C       HXSZZQZQC   1.1420   1.3570  2018-06-15\n",
       "27    000051   华夏沪深300ETF联接A   HXHS300ETFLJA   1.2230   1.2230  2018-06-15\n",
       "118   000061          华夏盛世混合          HXSSHH   0.7250   0.7250  2018-06-15\n",
       "13    000071       华夏恒生ETF联接       HXHSETFLJ   1.5294   1.5294  2018-06-15\n",
       "121   000075        华夏恒生联接现汇        HXHSLJXH   0.2378   0.2378  2018-06-15\n",
       "10    000121         华夏永福混合A         HXYFHHA   1.5970   1.5970  2018-06-15\n",
       "9     000945       华夏医疗健康混合A       HXYLJKHHA   1.6010   1.6010  2018-06-15\n",
       "11    000946       华夏医疗健康混合C       HXYLJKHHC   1.5740   1.5740  2018-06-15\n",
       "23    000948   华夏沪港通恒生ETF联接A   HXHGTHSETFLJA   1.2664   1.2664  2018-06-15\n",
       "64    000975  MSCI中国A股ETF联接A  MSCIZGAGETFLJA     1.04     1.04  2018-06-15\n",
       "62    001001         华夏债券A/B         HXZQA/B   1.0420   1.8720  2018-06-15\n",
       "67    001003           华夏债券C           HXZQC   1.0350   1.8250  2018-06-15\n",
       "47    001011         华夏希望债券A         HXXWZQA   1.1060   1.6260  2018-06-15\n",
       "50    001013         华夏希望债券C         HXXWZQC   1.0890   1.5890  2018-06-15\n",
       "18    001015    华夏沪深300指数增强A    HXHS300ZSZQA   1.3480   1.3480  2018-06-15\n",
       "19    001016    华夏沪深300指数增强C    HXHS300ZSZQC   1.3260   1.3260  2018-06-15\n",
       "34    001021       华夏亚债中国指数A       HXYZZGZSA     1.16   1.2650  2018-06-15\n",
       "40    001023       华夏亚债中国指数C       HXYZZGZSC     1.13   1.2350  2018-06-15\n",
       "25    001031       华夏安康优选债券A       HXAKYXZQA   1.2640   1.4240  2018-06-15\n",
       "26    001033       华夏安康优选债券C       HXAKYXZQC     1.24     1.40  2018-06-15\n",
       "120   001042          华夏领先股票          HXLXGP     0.56     0.56  2018-06-15\n",
       "..       ...             ...             ...      ...      ...         ...\n",
       "101   005177     华夏睿磐泰利定开混合A     HXRPTLDKHHA     0.99     0.99  2018-06-15\n",
       "102   005178     华夏睿磐泰利定开混合C     HXRPTLDKHHC   0.9886   0.9886  2018-06-15\n",
       "85    005213     华夏鼎旺三个月定开债A     HXDWSGYDKZA   1.0136   1.0136  2018-06-15\n",
       "148   005214     华夏鼎旺三个月定开债C     HXDWSGYDKZC                    2018-06-15\n",
       "145   005218      华夏聚惠(FOF)A        HXJHFOFA                    2018-06-15\n",
       "149   005219      华夏聚惠(FOF)C        HXJHFOFC                    2018-06-15\n",
       "92    005407     华夏鼎泰六个月定开债A     HXDTLGYDKZA   1.0013   1.0013  2018-06-15\n",
       "151   005408     华夏鼎泰六个月定开债C     HXDTLGYDKZC                    2018-06-15\n",
       "71    005449        华夏行业龙头混合        HXHYLTHH   1.0269   1.0269  2018-06-15\n",
       "72    005450      华夏稳盛灵活配置混合      HXWSLHPZHH   1.0236   1.0236  2018-06-15\n",
       "150   005534   华夏新时代混合(QDII)     HXXSDHHQDII                    2018-06-15\n",
       "83    005581     华夏信用债ETF联接A     HXXYZETFLJA   1.0148   1.0148  2018-06-15\n",
       "84    005582     华夏信用债ETF联接C     HXXYZETFLJC   1.0145   1.0145  2018-06-15\n",
       "29    005658   华夏沪深300ETF联接C   HXHS300ETFLJC   1.2210   1.2210  2018-06-15\n",
       "152   005698      华夏全球科技先锋混合      HXQQKJXFHH                    2018-06-15\n",
       "111   005733    华夏上证50ETF联接C    HXSZ50ETFLJC   0.9050   0.9050  2018-06-15\n",
       "24    005734   华夏沪港通恒生ETF联接C   HXHGTHSETFLJC   1.2659   1.2659  2018-06-15\n",
       "66    005735  MSCI中国A股ETF联接C  MSCIZGAGETFLJC   1.0390   1.0390  2018-06-15\n",
       "16    160311            华夏蓝筹            HXLC   1.4920   4.9830  2018-06-15\n",
       "77    160314     华夏行业混合(LOF)       HXHYHHLOF   1.0180     6.14  2018-06-15\n",
       "28    160322    华夏港股通精选股票LOF    HXGGTJXGPLOF   1.2228   1.2728  2018-06-15\n",
       "87    160323   华夏磐泰定开混合(LOF)     HXPTDKHHLOF   1.0115   1.0115  2018-06-15\n",
       "109   160324   华夏磐晟定开混合(LOF)     HXPSDKHHLOF   0.9447   0.9447  2018-06-15\n",
       "63    288001          华夏经典混合          HXJDHH   1.0410   3.4310  2018-06-15\n",
       "2     288002          华夏收入混合          HXSRHH   4.6180   6.0180  2018-06-15\n",
       "58    288102       华夏稳定双利债券C       HXWDSLZQC   1.0523   1.8594  2018-06-15\n",
       "33    501050    华夏上证50AH优选指数    HXSZ50AHYXZS   1.1730   1.1730  2018-06-15\n",
       "12    519029          华夏平稳增长          HXPWZZ   1.5310   2.3360  2018-06-15\n",
       "8     519908         华夏兴华混合A         HXXHHHA   1.6120   6.0310  2018-06-15\n",
       "17    519918          华夏兴和混合          HXXHHH   1.4850   3.8070  2018-06-15\n",
       "\n",
       "[153 rows x 6 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 根据基金公司获取基金列表\n",
    "df, msg = fund.get_fundlist_by_company('80000222')\n",
    "df.sort_values('fundcode', inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['全部开放基金', '股票型基金', '混合型基金', '债券型基金', '指数型基金', 'ETF联接基金', 'LOF基金', '分级基金', 'FOF基金', '理财基金', '分级A', '货币基金'])"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 获取基金类型列表\n",
    "type_list= fund.get_fund_type()\n",
    "type_list\n",
    "# ['全部开放基金',\n",
    "#  '股票型基金', '混合型基金', '债券型基金', '指数型基金', 'ETF联接基金', 'LOF基金', '分级基金', 'FOF基金',\n",
    "#  '理财基金', '分级A', '货币基金']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>fundcode</th>\n",
       "      <th>fundname</th>\n",
       "      <th>pingyin</th>\n",
       "      <th>nav</th>\n",
       "      <th>accu_nav</th>\n",
       "      <th>date</th>\n",
       "      <th>fund_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>000008</td>\n",
       "      <td>嘉实中证500ETF联接</td>\n",
       "      <td>JSZZ500ETFLJ</td>\n",
       "      <td>1.5245</td>\n",
       "      <td>1.5245</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>000042</td>\n",
       "      <td>中证财通可持续发展100指数A</td>\n",
       "      <td>ZZCTKCXFZ100ZSA</td>\n",
       "      <td>1.6741</td>\n",
       "      <td>1.6741</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>000051</td>\n",
       "      <td>华夏沪深300ETF联接A</td>\n",
       "      <td>HXHS300ETFLJA</td>\n",
       "      <td>1.2230</td>\n",
       "      <td>1.2230</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>000059</td>\n",
       "      <td>国联安中证医药100</td>\n",
       "      <td>GLAZZYY100</td>\n",
       "      <td>1.0424</td>\n",
       "      <td>1.6024</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>000082</td>\n",
       "      <td>嘉实研究阿尔法股票</td>\n",
       "      <td>JSYJAEFGP</td>\n",
       "      <td>1.3270</td>\n",
       "      <td>1.8820</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>000176</td>\n",
       "      <td>嘉实沪深300指数研究增强</td>\n",
       "      <td>JSHS300ZSYJZQ</td>\n",
       "      <td>1.2788</td>\n",
       "      <td>1.2788</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>000248</td>\n",
       "      <td>汇添富中证主要消费ETF联接</td>\n",
       "      <td>HTFZZZYXFETFLJ</td>\n",
       "      <td>1.6065</td>\n",
       "      <td>1.6065</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>000309</td>\n",
       "      <td>大摩品质生活精选股票</td>\n",
       "      <td>DMPZSHJXGP</td>\n",
       "      <td>1.7120</td>\n",
       "      <td>1.7120</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>000311</td>\n",
       "      <td>景顺长城沪深300增强</td>\n",
       "      <td>JSCCHS300ZQ</td>\n",
       "      <td>1.9880</td>\n",
       "      <td>2.3280</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>000312</td>\n",
       "      <td>华安沪深300增强A</td>\n",
       "      <td>HAHS300ZQA</td>\n",
       "      <td>1.5267</td>\n",
       "      <td>1.8867</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>000313</td>\n",
       "      <td>华安沪深300增强C</td>\n",
       "      <td>HAHS300ZQC</td>\n",
       "      <td>1.4786</td>\n",
       "      <td>1.8386</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>000368</td>\n",
       "      <td>汇添富沪深300安中指数</td>\n",
       "      <td>HTFHS300AZZS</td>\n",
       "      <td>1.4992</td>\n",
       "      <td>1.4992</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>000373</td>\n",
       "      <td>华安中证细分医药ETF联接A</td>\n",
       "      <td>HAZZXFYYETFLJA</td>\n",
       "      <td>1.5190</td>\n",
       "      <td>1.5190</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>000376</td>\n",
       "      <td>华安中证细分医药ETF联接C</td>\n",
       "      <td>HAZZXFYYETFLJC</td>\n",
       "      <td>1.4960</td>\n",
       "      <td>1.4960</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>000409</td>\n",
       "      <td>鹏华环保产业股票</td>\n",
       "      <td>PHHBCYGP</td>\n",
       "      <td>1.6020</td>\n",
       "      <td>1.6020</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>000411</td>\n",
       "      <td>景顺长城优质成长</td>\n",
       "      <td>JSCCYZCZ</td>\n",
       "      <td>1.1210</td>\n",
       "      <td>1.4710</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>000418</td>\n",
       "      <td>景顺长城成长之星</td>\n",
       "      <td>JSCCCZZX</td>\n",
       "      <td>1.7310</td>\n",
       "      <td>1.7310</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>000457</td>\n",
       "      <td>上投摩根核心成长</td>\n",
       "      <td>STMGHXCZ</td>\n",
       "      <td>1.8380</td>\n",
       "      <td>2.1470</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>000471</td>\n",
       "      <td>富国城镇发展股票</td>\n",
       "      <td>FGCZFZGP</td>\n",
       "      <td>1.33</td>\n",
       "      <td>1.83</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>000478</td>\n",
       "      <td>建信中证500指数增强A</td>\n",
       "      <td>JXZZ500ZSZQA</td>\n",
       "      <td>2.1257</td>\n",
       "      <td>2.1257</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>000513</td>\n",
       "      <td>富国高端制造行业股票</td>\n",
       "      <td>FGGDZZHYGP</td>\n",
       "      <td>1.5860</td>\n",
       "      <td>1.5860</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>000524</td>\n",
       "      <td>上投摩根民生需求</td>\n",
       "      <td>STMGMSXQ</td>\n",
       "      <td>1.50</td>\n",
       "      <td>1.9390</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>000549</td>\n",
       "      <td>华安大国新经济股票</td>\n",
       "      <td>HADGXJJGP</td>\n",
       "      <td>1.6710</td>\n",
       "      <td>1.6710</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000577</td>\n",
       "      <td>安信价值精选股票</td>\n",
       "      <td>AXJZJXGP</td>\n",
       "      <td>2.8250</td>\n",
       "      <td>2.8250</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>000586</td>\n",
       "      <td>景顺中小板创业板精选股票</td>\n",
       "      <td>JSZXBCYBJXGP</td>\n",
       "      <td>1.4930</td>\n",
       "      <td>1.4930</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>000592</td>\n",
       "      <td>建信改革红利股票</td>\n",
       "      <td>JXGGHLGP</td>\n",
       "      <td>2.0260</td>\n",
       "      <td>2.0260</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>000594</td>\n",
       "      <td>大摩进取优选股票</td>\n",
       "      <td>DMJQYXGP</td>\n",
       "      <td>1.7210</td>\n",
       "      <td>1.7210</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>000596</td>\n",
       "      <td>前海开源中证军工指数A</td>\n",
       "      <td>QHKYZZJGZSA</td>\n",
       "      <td>1.1130</td>\n",
       "      <td>1.1130</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>000613</td>\n",
       "      <td>国寿安保沪深300指数</td>\n",
       "      <td>GSABHS300ZS</td>\n",
       "      <td>0.9975</td>\n",
       "      <td>1.6575</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>000628</td>\n",
       "      <td>大成高新技术产业股票</td>\n",
       "      <td>DCGXJSCYGP</td>\n",
       "      <td>1.6440</td>\n",
       "      <td>1.6440</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>519193</td>\n",
       "      <td>万家消费成长</td>\n",
       "      <td>WJXFCZ</td>\n",
       "      <td>1.2798</td>\n",
       "      <td>1.2798</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>519300</td>\n",
       "      <td>大成沪深300指数</td>\n",
       "      <td>DCHS300ZS</td>\n",
       "      <td>1.0163</td>\n",
       "      <td>2.6039</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>519606</td>\n",
       "      <td>国泰金鑫</td>\n",
       "      <td>GTJX</td>\n",
       "      <td>1.7540</td>\n",
       "      <td>1.9040</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>519671</td>\n",
       "      <td>银河沪深300价值</td>\n",
       "      <td>YHHS300JZ</td>\n",
       "      <td>1.5570</td>\n",
       "      <td>1.5570</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>519673</td>\n",
       "      <td>银河康乐股票</td>\n",
       "      <td>YHKLGP</td>\n",
       "      <td>1.3690</td>\n",
       "      <td>1.3690</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>519677</td>\n",
       "      <td>银河定投宝腾讯济安指数</td>\n",
       "      <td>YHDTBTXJAZS</td>\n",
       "      <td>1.5720</td>\n",
       "      <td>1.5720</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>519686</td>\n",
       "      <td>交银180治理联接</td>\n",
       "      <td>JY180ZLLJ</td>\n",
       "      <td>1.2390</td>\n",
       "      <td>1.2390</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>519706</td>\n",
       "      <td>交银深证300联接</td>\n",
       "      <td>JYSZ300LJ</td>\n",
       "      <td>1.6720</td>\n",
       "      <td>1.6720</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>519714</td>\n",
       "      <td>交银消费新驱动股票</td>\n",
       "      <td>JYXFXQDGP</td>\n",
       "      <td>1.0730</td>\n",
       "      <td>2.5710</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>519931</td>\n",
       "      <td>长信港股通指数</td>\n",
       "      <td>CXGGTZS</td>\n",
       "      <td>1.2580</td>\n",
       "      <td>1.2580</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>519935</td>\n",
       "      <td>长信创新驱动股票</td>\n",
       "      <td>CXCXQDGP</td>\n",
       "      <td>1.1840</td>\n",
       "      <td>1.1840</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>519965</td>\n",
       "      <td>长信量化多策略股票A</td>\n",
       "      <td>CXLHDCLGPA</td>\n",
       "      <td>1.1670</td>\n",
       "      <td>1.1670</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>519975</td>\n",
       "      <td>长信量化中小盘股票</td>\n",
       "      <td>CXLHZXPGP</td>\n",
       "      <td>0.8170</td>\n",
       "      <td>1.2170</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>530010</td>\n",
       "      <td>建信责任联接</td>\n",
       "      <td>JXZRLJ</td>\n",
       "      <td>1.7644</td>\n",
       "      <td>1.7644</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>530015</td>\n",
       "      <td>建信深证60联接</td>\n",
       "      <td>JXSZ60LJ</td>\n",
       "      <td>1.8729</td>\n",
       "      <td>1.8729</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>530018</td>\n",
       "      <td>建信深证100增强</td>\n",
       "      <td>JXSZ100ZQ</td>\n",
       "      <td>1.7016</td>\n",
       "      <td>1.7016</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>540006</td>\n",
       "      <td>汇丰晋信大盘股票A</td>\n",
       "      <td>HFJXDPGPA</td>\n",
       "      <td>3.1269</td>\n",
       "      <td>3.1869</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>540007</td>\n",
       "      <td>汇丰晋信中小盘股票</td>\n",
       "      <td>HFJXZXPGP</td>\n",
       "      <td>1.1206</td>\n",
       "      <td>1.1406</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>540008</td>\n",
       "      <td>汇丰晋信低碳先锋</td>\n",
       "      <td>HFJXDTXF</td>\n",
       "      <td>1.2707</td>\n",
       "      <td>1.3707</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>540009</td>\n",
       "      <td>汇丰晋信消费红利</td>\n",
       "      <td>HFJXXFHL</td>\n",
       "      <td>1.0508</td>\n",
       "      <td>1.3678</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>540010</td>\n",
       "      <td>汇丰晋信科技先锋</td>\n",
       "      <td>HFJXKJXF</td>\n",
       "      <td>1.7663</td>\n",
       "      <td>1.7663</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>540012</td>\n",
       "      <td>汇丰晋信恒生龙头指数A</td>\n",
       "      <td>HFJXHSLTZSA</td>\n",
       "      <td>1.5568</td>\n",
       "      <td>1.9268</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>585001</td>\n",
       "      <td>东吴中证新兴指数</td>\n",
       "      <td>DWZZXXZS</td>\n",
       "      <td>1.1250</td>\n",
       "      <td>1.1250</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>590007</td>\n",
       "      <td>中邮上证380增强</td>\n",
       "      <td>ZYSZ380ZQ</td>\n",
       "      <td>1.0270</td>\n",
       "      <td>1.5370</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>660008</td>\n",
       "      <td>农银沪深300指数A</td>\n",
       "      <td>NYHS300ZSA</td>\n",
       "      <td>1.2580</td>\n",
       "      <td>1.2580</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>660011</td>\n",
       "      <td>农银中证500</td>\n",
       "      <td>NYZZ500</td>\n",
       "      <td>1.3885</td>\n",
       "      <td>1.3885</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>673090</td>\n",
       "      <td>西部利得个股精选股票</td>\n",
       "      <td>XBLDGGJXGP</td>\n",
       "      <td>1.0198</td>\n",
       "      <td>1.1418</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769</th>\n",
       "      <td>690008</td>\n",
       "      <td>民生中证资源指数</td>\n",
       "      <td>MSZZZYZS</td>\n",
       "      <td>0.7330</td>\n",
       "      <td>0.7330</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>700002</td>\n",
       "      <td>平安大华深证300</td>\n",
       "      <td>PADHSZ300</td>\n",
       "      <td>1.5820</td>\n",
       "      <td>1.6620</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>740101</td>\n",
       "      <td>长安沪深300非周期</td>\n",
       "      <td>CAHS300FZQ</td>\n",
       "      <td>1.0910</td>\n",
       "      <td>1.5950</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>股票型基金</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>846 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    fundcode         fundname          pingyin     nav accu_nav        date  \\\n",
       "74    000008     嘉实中证500ETF联接     JSZZ500ETFLJ  1.5245   1.5245  2018-06-15   \n",
       "40    000042  中证财通可持续发展100指数A  ZZCTKCXFZ100ZSA  1.6741   1.6741  2018-06-15   \n",
       "188   000051    华夏沪深300ETF联接A    HXHS300ETFLJA  1.2230   1.2230  2018-06-15   \n",
       "341   000059       国联安中证医药100       GLAZZYY100  1.0424   1.6024  2018-06-15   \n",
       "141   000082        嘉实研究阿尔法股票        JSYJAEFGP  1.3270   1.8820  2018-06-15   \n",
       "165   000176    嘉实沪深300指数研究增强    JSHS300ZSYJZQ  1.2788   1.2788  2018-06-15   \n",
       "54    000248   汇添富中证主要消费ETF联接   HTFZZZYXFETFLJ  1.6065   1.6065  2018-06-15   \n",
       "33    000309       大摩品质生活精选股票       DMPZSHJXGP  1.7120   1.7120  2018-06-15   \n",
       "14    000311      景顺长城沪深300增强      JSCCHS300ZQ  1.9880   2.3280  2018-06-15   \n",
       "73    000312       华安沪深300增强A       HAHS300ZQA  1.5267   1.8867  2018-06-15   \n",
       "88    000313       华安沪深300增强C       HAHS300ZQC  1.4786   1.8386  2018-06-15   \n",
       "81    000368     汇添富沪深300安中指数     HTFHS300AZZS  1.4992   1.4992  2018-06-15   \n",
       "75    000373   华安中证细分医药ETF联接A   HAZZXFYYETFLJA  1.5190   1.5190  2018-06-15   \n",
       "84    000376   华安中证细分医药ETF联接C   HAZZXFYYETFLJC  1.4960   1.4960  2018-06-15   \n",
       "57    000409         鹏华环保产业股票         PHHBCYGP  1.6020   1.6020  2018-06-15   \n",
       "271   000411         景顺长城优质成长         JSCCYZCZ  1.1210   1.4710  2018-06-15   \n",
       "29    000418         景顺长城成长之星         JSCCCZZX  1.7310   1.7310  2018-06-15   \n",
       "17    000457         上投摩根核心成长         STMGHXCZ  1.8380   2.1470  2018-06-15   \n",
       "138   000471         富国城镇发展股票         FGCZFZGP    1.33     1.83  2018-06-15   \n",
       "7     000478     建信中证500指数增强A     JXZZ500ZSZQA  2.1257   2.1257  2018-06-15   \n",
       "60    000513       富国高端制造行业股票       FGGDZZHYGP  1.5860   1.5860  2018-06-15   \n",
       "79    000524         上投摩根民生需求         STMGMSXQ    1.50   1.9390  2018-06-15   \n",
       "43    000549        华安大国新经济股票        HADGXJJGP  1.6710   1.6710  2018-06-15   \n",
       "1     000577         安信价值精选股票         AXJZJXGP  2.8250   2.8250  2018-06-15   \n",
       "85    000586     景顺中小板创业板精选股票     JSZXBCYBJXGP  1.4930   1.4930  2018-06-15   \n",
       "13    000592         建信改革红利股票         JXGGHLGP  2.0260   2.0260  2018-06-15   \n",
       "32    000594         大摩进取优选股票         DMJQYXGP  1.7210   1.7210  2018-06-15   \n",
       "279   000596      前海开源中证军工指数A      QHKYZZJGZSA  1.1130   1.1130  2018-06-15   \n",
       "436   000613      国寿安保沪深300指数      GSABHS300ZS  0.9975   1.6575  2018-06-15   \n",
       "49    000628       大成高新技术产业股票       DCGXJSCYGP  1.6440   1.6440  2018-06-15   \n",
       "..       ...              ...              ...     ...      ...         ...   \n",
       "162   519193           万家消费成长           WJXFCZ  1.2798   1.2798  2018-06-15   \n",
       "382   519300        大成沪深300指数        DCHS300ZS  1.0163   2.6039  2018-06-15   \n",
       "25    519606             国泰金鑫             GTJX  1.7540   1.9040  2018-06-15   \n",
       "67    519671        银河沪深300价值        YHHS300JZ  1.5570   1.5570  2018-06-15   \n",
       "120   519673           银河康乐股票           YHKLGP  1.3690   1.3690  2018-06-15   \n",
       "66    519677      银河定投宝腾讯济安指数      YHDTBTXJAZS  1.5720   1.5720  2018-06-15   \n",
       "183   519686        交银180治理联接        JY180ZLLJ  1.2390   1.2390  2018-06-15   \n",
       "42    519706        交银深证300联接        JYSZ300LJ  1.6720   1.6720  2018-06-15   \n",
       "309   519714        交银消费新驱动股票        JYXFXQDGP  1.0730   2.5710  2018-06-15   \n",
       "177   519931          长信港股通指数          CXGGTZS  1.2580   1.2580  2018-06-15   \n",
       "217   519935         长信创新驱动股票         CXCXQDGP  1.1840   1.1840  2018-06-15   \n",
       "242   519965       长信量化多策略股票A       CXLHDCLGPA  1.1670   1.1670  2018-06-15   \n",
       "701   519975        长信量化中小盘股票        CXLHZXPGP  0.8170   1.2170  2018-06-15   \n",
       "24    530010           建信责任联接           JXZRLJ  1.7644   1.7644  2018-06-15   \n",
       "15    530015         建信深证60联接         JXSZ60LJ  1.8729   1.8729  2018-06-15   \n",
       "34    530018        建信深证100增强        JXSZ100ZQ  1.7016   1.7016  2018-06-15   \n",
       "0     540006        汇丰晋信大盘股票A        HFJXDPGPA  3.1269   3.1869  2018-06-15   \n",
       "272   540007        汇丰晋信中小盘股票        HFJXZXPGP  1.1206   1.1406  2018-06-15   \n",
       "168   540008         汇丰晋信低碳先锋         HFJXDTXF  1.2707   1.3707  2018-06-15   \n",
       "329   540009         汇丰晋信消费红利         HFJXXFHL  1.0508   1.3678  2018-06-15   \n",
       "23    540010         汇丰晋信科技先锋         HFJXKJXF  1.7663   1.7663  2018-06-15   \n",
       "68    540012      汇丰晋信恒生龙头指数A      HFJXHSLTZSA  1.5568   1.9268  2018-06-15   \n",
       "267   585001         东吴中证新兴指数         DWZZXXZS  1.1250   1.1250  2018-06-15   \n",
       "369   590007        中邮上证380增强        ZYSZ380ZQ  1.0270   1.5370  2018-06-15   \n",
       "176   660008       农银沪深300指数A       NYHS300ZSA  1.2580   1.2580  2018-06-15   \n",
       "112   660011          农银中证500          NYZZ500  1.3885   1.3885  2018-06-15   \n",
       "378   673090       西部利得个股精选股票       XBLDGGJXGP  1.0198   1.1418  2018-06-15   \n",
       "769   690008         民生中证资源指数         MSZZZYZS  0.7330   0.7330  2018-06-15   \n",
       "64    700002        平安大华深证300        PADHSZ300  1.5820   1.6620  2018-06-15   \n",
       "293   740101       长安沪深300非周期       CAHS300FZQ  1.0910   1.5950  2018-06-15   \n",
       "\n",
       "    fund_type  \n",
       "74      股票型基金  \n",
       "40      股票型基金  \n",
       "188     股票型基金  \n",
       "341     股票型基金  \n",
       "141     股票型基金  \n",
       "165     股票型基金  \n",
       "54      股票型基金  \n",
       "33      股票型基金  \n",
       "14      股票型基金  \n",
       "73      股票型基金  \n",
       "88      股票型基金  \n",
       "81      股票型基金  \n",
       "75      股票型基金  \n",
       "84      股票型基金  \n",
       "57      股票型基金  \n",
       "271     股票型基金  \n",
       "29      股票型基金  \n",
       "17      股票型基金  \n",
       "138     股票型基金  \n",
       "7       股票型基金  \n",
       "60      股票型基金  \n",
       "79      股票型基金  \n",
       "43      股票型基金  \n",
       "1       股票型基金  \n",
       "85      股票型基金  \n",
       "13      股票型基金  \n",
       "32      股票型基金  \n",
       "279     股票型基金  \n",
       "436     股票型基金  \n",
       "49      股票型基金  \n",
       "..        ...  \n",
       "162     股票型基金  \n",
       "382     股票型基金  \n",
       "25      股票型基金  \n",
       "67      股票型基金  \n",
       "120     股票型基金  \n",
       "66      股票型基金  \n",
       "183     股票型基金  \n",
       "42      股票型基金  \n",
       "309     股票型基金  \n",
       "177     股票型基金  \n",
       "217     股票型基金  \n",
       "242     股票型基金  \n",
       "701     股票型基金  \n",
       "24      股票型基金  \n",
       "15      股票型基金  \n",
       "34      股票型基金  \n",
       "0       股票型基金  \n",
       "272     股票型基金  \n",
       "168     股票型基金  \n",
       "329     股票型基金  \n",
       "23      股票型基金  \n",
       "68      股票型基金  \n",
       "267     股票型基金  \n",
       "369     股票型基金  \n",
       "176     股票型基金  \n",
       "112     股票型基金  \n",
       "378     股票型基金  \n",
       "769     股票型基金  \n",
       "64      股票型基金  \n",
       "293     股票型基金  \n",
       "\n",
       "[846 rows x 7 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 根据类型获取基金信息\n",
    "df, msg = fund.get_fundlist_by_type('股票型基金')\n",
    "df.sort_values('fundcode', inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>fundcode</th>\n",
       "      <th>fundname</th>\n",
       "      <th>pingyin</th>\n",
       "      <th>nav</th>\n",
       "      <th>accu_nav</th>\n",
       "      <th>date</th>\n",
       "      <th>fund_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>005156</td>\n",
       "      <td>嘉实领航资产配置混合A</td>\n",
       "      <td>JSLHZCPZHHA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>005157</td>\n",
       "      <td>嘉实领航资产配置混合C</td>\n",
       "      <td>JSLHZCPZHHC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>005215</td>\n",
       "      <td>南方全天候策略(FOF)A</td>\n",
       "      <td>NFQTHCLFOFA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>005216</td>\n",
       "      <td>南方全天候策略(FOF)C</td>\n",
       "      <td>NFQTHCLFOFC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>005217</td>\n",
       "      <td>建信福泽安泰混合(FOF)</td>\n",
       "      <td>JXFZATHHFOF</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>005218</td>\n",
       "      <td>华夏聚惠(FOF)A</td>\n",
       "      <td>HXJHFOFA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>005219</td>\n",
       "      <td>华夏聚惠(FOF)C</td>\n",
       "      <td>HXJHFOFC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>005220</td>\n",
       "      <td>海富通聚优精选混合(FOF)</td>\n",
       "      <td>HFTJYJXHHFOF</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>005221</td>\n",
       "      <td>泰达宏利全能混合(FOF)A</td>\n",
       "      <td>TDHLQNHHFOFA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>005222</td>\n",
       "      <td>泰达宏利全能混合(FOF)C</td>\n",
       "      <td>TDHLQNHHFOFC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>005758</td>\n",
       "      <td>中融量化精选(FOF)A</td>\n",
       "      <td>ZRLHJXFOFA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>005759</td>\n",
       "      <td>中融量化精选(FOF)C</td>\n",
       "      <td>ZRLHJXFOFC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>005809</td>\n",
       "      <td>前海开源裕源(FOF)</td>\n",
       "      <td>QHKYYYFOF</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>FOF基金</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   fundcode        fundname       pingyin nav accu_nav        date fund_type\n",
       "4    005156     嘉实领航资产配置混合A   JSLHZCPZHHA               2018-06-15     FOF基金\n",
       "5    005157     嘉实领航资产配置混合C   JSLHZCPZHHC               2018-06-15     FOF基金\n",
       "7    005215   南方全天候策略(FOF)A   NFQTHCLFOFA               2018-06-15     FOF基金\n",
       "3    005216   南方全天候策略(FOF)C   NFQTHCLFOFC               2018-06-15     FOF基金\n",
       "9    005217   建信福泽安泰混合(FOF)   JXFZATHHFOF               2018-06-15     FOF基金\n",
       "2    005218      华夏聚惠(FOF)A      HXJHFOFA               2018-06-15     FOF基金\n",
       "8    005219      华夏聚惠(FOF)C      HXJHFOFC               2018-06-15     FOF基金\n",
       "6    005220  海富通聚优精选混合(FOF)  HFTJYJXHHFOF               2018-06-15     FOF基金\n",
       "0    005221  泰达宏利全能混合(FOF)A  TDHLQNHHFOFA               2018-06-15     FOF基金\n",
       "1    005222  泰达宏利全能混合(FOF)C  TDHLQNHHFOFC               2018-06-15     FOF基金\n",
       "10   005758    中融量化精选(FOF)A    ZRLHJXFOFA               2018-06-15     FOF基金\n",
       "11   005759    中融量化精选(FOF)C    ZRLHJXFOFC               2018-06-15     FOF基金\n",
       "12   005809     前海开源裕源(FOF)     QHKYYYFOF               2018-06-15     FOF基金"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 根据类型获取基金信息\n",
    "df, msg = fund.get_fundlist_by_type('FOF基金')\n",
    "df.sort_values('fundcode', inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 根据基金代码，获取基金历史净值\n",
    "# date nav1 nav2\n",
    "# 对于‘理财基金’、‘货币基金’，nav1, nav2 分别表示万分收益和7日年华收益\n",
    "# 对于其他类型的基金，nav1, nav2分别表示 单位净值 和 累计净值"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>nav1</th>\n",
       "      <th>nav2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>13.9360</td>\n",
       "      <td>18.1160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-06-14</td>\n",
       "      <td>14.0180</td>\n",
       "      <td>18.1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-06-13</td>\n",
       "      <td>14.1160</td>\n",
       "      <td>18.2960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-06-12</td>\n",
       "      <td>14.2020</td>\n",
       "      <td>18.3820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-06-11</td>\n",
       "      <td>13.9780</td>\n",
       "      <td>18.1580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018-06-08</td>\n",
       "      <td>14.0060</td>\n",
       "      <td>18.1860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-06-07</td>\n",
       "      <td>14.1110</td>\n",
       "      <td>18.2910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2018-06-06</td>\n",
       "      <td>14.1130</td>\n",
       "      <td>18.2930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2018-06-05</td>\n",
       "      <td>14.0460</td>\n",
       "      <td>18.2260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2018-06-04</td>\n",
       "      <td>13.8790</td>\n",
       "      <td>18.0590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018-06-01</td>\n",
       "      <td>13.6430</td>\n",
       "      <td>17.8230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2018-05-31</td>\n",
       "      <td>13.7850</td>\n",
       "      <td>17.9650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-05-30</td>\n",
       "      <td>13.4830</td>\n",
       "      <td>17.6630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018-05-29</td>\n",
       "      <td>13.6320</td>\n",
       "      <td>17.8120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-05-28</td>\n",
       "      <td>13.6990</td>\n",
       "      <td>17.8790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2018-05-25</td>\n",
       "      <td>13.5460</td>\n",
       "      <td>17.7260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-05-24</td>\n",
       "      <td>13.5100</td>\n",
       "      <td>17.6900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2018-05-23</td>\n",
       "      <td>13.6200</td>\n",
       "      <td>17.8000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-05-22</td>\n",
       "      <td>13.8460</td>\n",
       "      <td>18.0260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>13.8930</td>\n",
       "      <td>18.0730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-05-18</td>\n",
       "      <td>13.7510</td>\n",
       "      <td>17.9310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2018-05-17</td>\n",
       "      <td>13.6360</td>\n",
       "      <td>17.8160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-05-16</td>\n",
       "      <td>13.8020</td>\n",
       "      <td>17.9820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2018-05-15</td>\n",
       "      <td>13.8280</td>\n",
       "      <td>18.0080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2018-05-14</td>\n",
       "      <td>13.7950</td>\n",
       "      <td>17.9750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2018-05-11</td>\n",
       "      <td>13.6020</td>\n",
       "      <td>17.7820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2018-05-10</td>\n",
       "      <td>13.6930</td>\n",
       "      <td>17.8730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2018-05-09</td>\n",
       "      <td>13.6100</td>\n",
       "      <td>17.7900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2018-05-08</td>\n",
       "      <td>13.6170</td>\n",
       "      <td>17.7970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2018-05-07</td>\n",
       "      <td>13.4980</td>\n",
       "      <td>17.6780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>2004-10-22</td>\n",
       "      <td>1.0100</td>\n",
       "      <td>1.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>2004-10-21</td>\n",
       "      <td>1.0010</td>\n",
       "      <td>1.0010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>2004-10-20</td>\n",
       "      <td>1.0050</td>\n",
       "      <td>1.0050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>2004-10-19</td>\n",
       "      <td>1.0050</td>\n",
       "      <td>1.0050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>2004-10-18</td>\n",
       "      <td>1.0020</td>\n",
       "      <td>1.0020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>2004-10-15</td>\n",
       "      <td>1.0020</td>\n",
       "      <td>1.0020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>2004-10-14</td>\n",
       "      <td>1.0010</td>\n",
       "      <td>1.0010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>2004-10-13</td>\n",
       "      <td>1.0090</td>\n",
       "      <td>1.0090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>2004-10-12</td>\n",
       "      <td>1.0100</td>\n",
       "      <td>1.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>2004-10-11</td>\n",
       "      <td>1.0150</td>\n",
       "      <td>1.0150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>2004-10-08</td>\n",
       "      <td>1.0180</td>\n",
       "      <td>1.0180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>2004-09-30</td>\n",
       "      <td>1.0140</td>\n",
       "      <td>1.0140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>2004-09-29</td>\n",
       "      <td>1.0170</td>\n",
       "      <td>1.0170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>2004-09-28</td>\n",
       "      <td>1.0210</td>\n",
       "      <td>1.0210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>2004-09-27</td>\n",
       "      <td>1.0190</td>\n",
       "      <td>1.0190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>2004-09-24</td>\n",
       "      <td>1.0180</td>\n",
       "      <td>1.0180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>2004-09-23</td>\n",
       "      <td>1.0190</td>\n",
       "      <td>1.0190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>2004-09-22</td>\n",
       "      <td>1.0140</td>\n",
       "      <td>1.0140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>2004-09-21</td>\n",
       "      <td>1.0150</td>\n",
       "      <td>1.0150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>2004-09-20</td>\n",
       "      <td>1.0170</td>\n",
       "      <td>1.0170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>2004-09-17</td>\n",
       "      <td>1.0090</td>\n",
       "      <td>1.0090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>2004-09-16</td>\n",
       "      <td>1.0040</td>\n",
       "      <td>1.0040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>2004-09-15</td>\n",
       "      <td>1.0020</td>\n",
       "      <td>1.0020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>2004-09-14</td>\n",
       "      <td>0.9960</td>\n",
       "      <td>0.9960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>2004-09-10</td>\n",
       "      <td>0.9950</td>\n",
       "      <td>0.9950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>2004-09-03</td>\n",
       "      <td>0.9970</td>\n",
       "      <td>0.9970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>2004-08-27</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>2004-08-20</td>\n",
       "      <td>1.0010</td>\n",
       "      <td>1.0010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>2004-08-13</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>2004-08-11</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3365 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date     nav1     nav2\n",
       "0    2018-06-15  13.9360  18.1160\n",
       "1    2018-06-14  14.0180  18.1980\n",
       "2    2018-06-13  14.1160  18.2960\n",
       "3    2018-06-12  14.2020  18.3820\n",
       "4    2018-06-11  13.9780  18.1580\n",
       "5    2018-06-08  14.0060  18.1860\n",
       "6    2018-06-07  14.1110  18.2910\n",
       "7    2018-06-06  14.1130  18.2930\n",
       "8    2018-06-05  14.0460  18.2260\n",
       "9    2018-06-04  13.8790  18.0590\n",
       "10   2018-06-01  13.6430  17.8230\n",
       "11   2018-05-31  13.7850  17.9650\n",
       "12   2018-05-30  13.4830  17.6630\n",
       "13   2018-05-29  13.6320  17.8120\n",
       "14   2018-05-28  13.6990  17.8790\n",
       "15   2018-05-25  13.5460  17.7260\n",
       "16   2018-05-24  13.5100  17.6900\n",
       "17   2018-05-23  13.6200  17.8000\n",
       "18   2018-05-22  13.8460  18.0260\n",
       "19   2018-05-21  13.8930  18.0730\n",
       "20   2018-05-18  13.7510  17.9310\n",
       "21   2018-05-17  13.6360  17.8160\n",
       "22   2018-05-16  13.8020  17.9820\n",
       "23   2018-05-15  13.8280  18.0080\n",
       "24   2018-05-14  13.7950  17.9750\n",
       "25   2018-05-11  13.6020  17.7820\n",
       "26   2018-05-10  13.6930  17.8730\n",
       "27   2018-05-09  13.6100  17.7900\n",
       "28   2018-05-08  13.6170  17.7970\n",
       "29   2018-05-07  13.4980  17.6780\n",
       "..          ...      ...      ...\n",
       "335  2004-10-22   1.0100   1.0100\n",
       "336  2004-10-21   1.0010   1.0010\n",
       "337  2004-10-20   1.0050   1.0050\n",
       "338  2004-10-19   1.0050   1.0050\n",
       "339  2004-10-18   1.0020   1.0020\n",
       "340  2004-10-15   1.0020   1.0020\n",
       "341  2004-10-14   1.0010   1.0010\n",
       "342  2004-10-13   1.0090   1.0090\n",
       "343  2004-10-12   1.0100   1.0100\n",
       "344  2004-10-11   1.0150   1.0150\n",
       "345  2004-10-08   1.0180   1.0180\n",
       "346  2004-09-30   1.0140   1.0140\n",
       "347  2004-09-29   1.0170   1.0170\n",
       "348  2004-09-28   1.0210   1.0210\n",
       "349  2004-09-27   1.0190   1.0190\n",
       "350  2004-09-24   1.0180   1.0180\n",
       "351  2004-09-23   1.0190   1.0190\n",
       "352  2004-09-22   1.0140   1.0140\n",
       "353  2004-09-21   1.0150   1.0150\n",
       "354  2004-09-20   1.0170   1.0170\n",
       "355  2004-09-17   1.0090   1.0090\n",
       "356  2004-09-16   1.0040   1.0040\n",
       "357  2004-09-15   1.0020   1.0020\n",
       "358  2004-09-14   0.9960   0.9960\n",
       "359  2004-09-10   0.9950   0.9950\n",
       "360  2004-09-03   0.9970   0.9970\n",
       "361  2004-08-27   1.0000   1.0000\n",
       "362  2004-08-20   1.0010   1.0010\n",
       "363  2004-08-13   1.0000   1.0000\n",
       "364  2004-08-11   1.0000   1.0000\n",
       "\n",
       "[3365 rows x 3 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 华夏大盘\n",
    "df, msg = fund.get_fund_nav('000011')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>nav1</th>\n",
       "      <th>nav2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-06-18</td>\n",
       "      <td>1.0125</td>\n",
       "      <td>3.7800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-06-17</td>\n",
       "      <td>1.0150</td>\n",
       "      <td>3.7780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-06-16</td>\n",
       "      <td>1.0155</td>\n",
       "      <td>3.7730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>1.0156</td>\n",
       "      <td>3.7680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-06-14</td>\n",
       "      <td>1.0190</td>\n",
       "      <td>3.7620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018-06-13</td>\n",
       "      <td>1.0190</td>\n",
       "      <td>3.7490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-06-12</td>\n",
       "      <td>1.0188</td>\n",
       "      <td>3.7380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2018-06-11</td>\n",
       "      <td>1.0103</td>\n",
       "      <td>3.7310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2018-06-10</td>\n",
       "      <td>1.0051</td>\n",
       "      <td>3.7320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2018-06-09</td>\n",
       "      <td>1.0055</td>\n",
       "      <td>3.7330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018-06-08</td>\n",
       "      <td>1.0056</td>\n",
       "      <td>3.7340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2018-06-07</td>\n",
       "      <td>0.9942</td>\n",
       "      <td>3.7340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-06-06</td>\n",
       "      <td>0.9998</td>\n",
       "      <td>3.7490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018-06-05</td>\n",
       "      <td>1.0058</td>\n",
       "      <td>3.7540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-06-04</td>\n",
       "      <td>1.0106</td>\n",
       "      <td>3.7570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2018-06-03</td>\n",
       "      <td>1.0073</td>\n",
       "      <td>3.7530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-06-02</td>\n",
       "      <td>1.0075</td>\n",
       "      <td>3.7480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2018-06-01</td>\n",
       "      <td>1.0065</td>\n",
       "      <td>3.7440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-05-31</td>\n",
       "      <td>1.0217</td>\n",
       "      <td>3.7390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2018-05-30</td>\n",
       "      <td>1.0090</td>\n",
       "      <td>3.7270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-05-29</td>\n",
       "      <td>1.0108</td>\n",
       "      <td>3.7200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2018-05-28</td>\n",
       "      <td>1.0034</td>\n",
       "      <td>3.7150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-05-27</td>\n",
       "      <td>0.9988</td>\n",
       "      <td>3.7130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2018-05-26</td>\n",
       "      <td>0.9989</td>\n",
       "      <td>3.7120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2018-05-25</td>\n",
       "      <td>0.9982</td>\n",
       "      <td>3.7120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2018-05-24</td>\n",
       "      <td>0.9986</td>\n",
       "      <td>3.7230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2018-05-23</td>\n",
       "      <td>0.9967</td>\n",
       "      <td>3.7230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2018-05-22</td>\n",
       "      <td>1.0020</td>\n",
       "      <td>3.7280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>0.9990</td>\n",
       "      <td>3.7370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2018-05-20</td>\n",
       "      <td>0.9969</td>\n",
       "      <td>3.7430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>814</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>1.6518</td>\n",
       "      <td>6.2990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>1.6521</td>\n",
       "      <td>6.1920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>816</th>\n",
       "      <td>2013-06-28</td>\n",
       "      <td>1.6823</td>\n",
       "      <td>6.0840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>817</th>\n",
       "      <td>2013-06-27</td>\n",
       "      <td>1.6592</td>\n",
       "      <td>5.9910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>818</th>\n",
       "      <td>2013-06-26</td>\n",
       "      <td>1.7198</td>\n",
       "      <td>5.8600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>819</th>\n",
       "      <td>2013-06-25</td>\n",
       "      <td>1.7863</td>\n",
       "      <td>5.6580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>2013-06-24</td>\n",
       "      <td>1.5650</td>\n",
       "      <td>5.4670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>821</th>\n",
       "      <td>2013-06-23</td>\n",
       "      <td>1.4575</td>\n",
       "      <td>5.4190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822</th>\n",
       "      <td>2013-06-22</td>\n",
       "      <td>1.4577</td>\n",
       "      <td>5.3200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823</th>\n",
       "      <td>2013-06-21</td>\n",
       "      <td>1.5131</td>\n",
       "      <td>5.2220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>2013-06-20</td>\n",
       "      <td>1.4237</td>\n",
       "      <td>5.0960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825</th>\n",
       "      <td>2013-06-19</td>\n",
       "      <td>1.3535</td>\n",
       "      <td>4.9680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>2013-06-18</td>\n",
       "      <td>1.4387</td>\n",
       "      <td>4.6760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>2013-06-17</td>\n",
       "      <td>1.4768</td>\n",
       "      <td>4.3380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>828</th>\n",
       "      <td>2013-06-16</td>\n",
       "      <td>1.2782</td>\n",
       "      <td>3.9810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>2013-06-15</td>\n",
       "      <td>1.2784</td>\n",
       "      <td>3.7320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>830</th>\n",
       "      <td>2013-06-14</td>\n",
       "      <td>1.2829</td>\n",
       "      <td>3.4840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>831</th>\n",
       "      <td>2013-06-13</td>\n",
       "      <td>1.1907</td>\n",
       "      <td>3.2340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>832</th>\n",
       "      <td>2013-06-12</td>\n",
       "      <td>0.8188</td>\n",
       "      <td>3.0350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>2013-06-11</td>\n",
       "      <td>0.8189</td>\n",
       "      <td>3.0360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>834</th>\n",
       "      <td>2013-06-10</td>\n",
       "      <td>0.8190</td>\n",
       "      <td>3.0360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>2013-06-09</td>\n",
       "      <td>0.8190</td>\n",
       "      <td>3.0370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>836</th>\n",
       "      <td>2013-06-08</td>\n",
       "      <td>0.8191</td>\n",
       "      <td>3.0390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>837</th>\n",
       "      <td>2013-06-07</td>\n",
       "      <td>0.8193</td>\n",
       "      <td>3.0410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>2013-06-06</td>\n",
       "      <td>0.8199</td>\n",
       "      <td>3.0430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>2013-06-05</td>\n",
       "      <td>0.8200</td>\n",
       "      <td>3.0230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>2013-06-04</td>\n",
       "      <td>0.8200</td>\n",
       "      <td>2.7720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>841</th>\n",
       "      <td>2013-06-03</td>\n",
       "      <td>0.8201</td>\n",
       "      <td>2.7280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>842</th>\n",
       "      <td>2013-06-02</td>\n",
       "      <td>3.6037</td>\n",
       "      <td>2.6650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>2013-05-30</td>\n",
       "      <td>1.1349</td>\n",
       "      <td>2.0930</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1844 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date    nav1    nav2\n",
       "0    2018-06-18  1.0125  3.7800\n",
       "1    2018-06-17  1.0150  3.7780\n",
       "2    2018-06-16  1.0155  3.7730\n",
       "3    2018-06-15  1.0156  3.7680\n",
       "4    2018-06-14  1.0190  3.7620\n",
       "5    2018-06-13  1.0190  3.7490\n",
       "6    2018-06-12  1.0188  3.7380\n",
       "7    2018-06-11  1.0103  3.7310\n",
       "8    2018-06-10  1.0051  3.7320\n",
       "9    2018-06-09  1.0055  3.7330\n",
       "10   2018-06-08  1.0056  3.7340\n",
       "11   2018-06-07  0.9942  3.7340\n",
       "12   2018-06-06  0.9998  3.7490\n",
       "13   2018-06-05  1.0058  3.7540\n",
       "14   2018-06-04  1.0106  3.7570\n",
       "15   2018-06-03  1.0073  3.7530\n",
       "16   2018-06-02  1.0075  3.7480\n",
       "17   2018-06-01  1.0065  3.7440\n",
       "18   2018-05-31  1.0217  3.7390\n",
       "19   2018-05-30  1.0090  3.7270\n",
       "20   2018-05-29  1.0108  3.7200\n",
       "21   2018-05-28  1.0034  3.7150\n",
       "22   2018-05-27  0.9988  3.7130\n",
       "23   2018-05-26  0.9989  3.7120\n",
       "24   2018-05-25  0.9982  3.7120\n",
       "25   2018-05-24  0.9986  3.7230\n",
       "26   2018-05-23  0.9967  3.7230\n",
       "27   2018-05-22  1.0020  3.7280\n",
       "28   2018-05-21  0.9990  3.7370\n",
       "29   2018-05-20  0.9969  3.7430\n",
       "..          ...     ...     ...\n",
       "814  2013-06-30  1.6518  6.2990\n",
       "815  2013-06-29  1.6521  6.1920\n",
       "816  2013-06-28  1.6823  6.0840\n",
       "817  2013-06-27  1.6592  5.9910\n",
       "818  2013-06-26  1.7198  5.8600\n",
       "819  2013-06-25  1.7863  5.6580\n",
       "820  2013-06-24  1.5650  5.4670\n",
       "821  2013-06-23  1.4575  5.4190\n",
       "822  2013-06-22  1.4577  5.3200\n",
       "823  2013-06-21  1.5131  5.2220\n",
       "824  2013-06-20  1.4237  5.0960\n",
       "825  2013-06-19  1.3535  4.9680\n",
       "826  2013-06-18  1.4387  4.6760\n",
       "827  2013-06-17  1.4768  4.3380\n",
       "828  2013-06-16  1.2782  3.9810\n",
       "829  2013-06-15  1.2784  3.7320\n",
       "830  2013-06-14  1.2829  3.4840\n",
       "831  2013-06-13  1.1907  3.2340\n",
       "832  2013-06-12  0.8188  3.0350\n",
       "833  2013-06-11  0.8189  3.0360\n",
       "834  2013-06-10  0.8190  3.0360\n",
       "835  2013-06-09  0.8190  3.0370\n",
       "836  2013-06-08  0.8191  3.0390\n",
       "837  2013-06-07  0.8193  3.0410\n",
       "838  2013-06-06  0.8199  3.0430\n",
       "839  2013-06-05  0.8200  3.0230\n",
       "840  2013-06-04  0.8200  2.7720\n",
       "841  2013-06-03  0.8201  2.7280\n",
       "842  2013-06-02  3.6037  2.6650\n",
       "843  2013-05-30  1.1349  2.0930\n",
       "\n",
       "[1844 rows x 3 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 余额宝\n",
    "df, msg = fund.get_fund_nav('000198')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100% (131 of 131) |######################| Elapsed Time: 0:04:29 ETA:  00:00:00"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>fundcode</th>\n",
       "      <th>fundname</th>\n",
       "      <th>pingyin</th>\n",
       "      <th>nav</th>\n",
       "      <th>accu_nav</th>\n",
       "      <th>date</th>\n",
       "      <th>companyname</th>\n",
       "      <th>companyid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000577</td>\n",
       "      <td>安信价值精选股票</td>\n",
       "      <td>AXJZJXGP</td>\n",
       "      <td>2.8250</td>\n",
       "      <td>2.8250</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000974</td>\n",
       "      <td>安信消费医药股票</td>\n",
       "      <td>AXXFYYGP</td>\n",
       "      <td>1.54</td>\n",
       "      <td>1.54</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>001287</td>\n",
       "      <td>安信优势增长混合A</td>\n",
       "      <td>AXYSZZHHA</td>\n",
       "      <td>1.5114</td>\n",
       "      <td>1.5114</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>002036</td>\n",
       "      <td>安信优势增长混合C</td>\n",
       "      <td>AXYSZZHHC</td>\n",
       "      <td>1.5057</td>\n",
       "      <td>1.5057</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>001583</td>\n",
       "      <td>安信新常态股票</td>\n",
       "      <td>AXXCTGP</td>\n",
       "      <td>1.3210</td>\n",
       "      <td>1.3210</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>001185</td>\n",
       "      <td>安信动态策略混合A</td>\n",
       "      <td>AXDTCLHHA</td>\n",
       "      <td>1.2587</td>\n",
       "      <td>1.2587</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>002029</td>\n",
       "      <td>安信动态策略混合C</td>\n",
       "      <td>AXDTCLHHC</td>\n",
       "      <td>1.2509</td>\n",
       "      <td>1.2509</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>001338</td>\n",
       "      <td>安信稳健增值混合C</td>\n",
       "      <td>AXWJZZHHC</td>\n",
       "      <td>1.2394</td>\n",
       "      <td>1.2394</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>004393</td>\n",
       "      <td>安信合作创新灵活配置混合</td>\n",
       "      <td>AXHZCXLHPZHH</td>\n",
       "      <td>1.2261</td>\n",
       "      <td>1.2261</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>001316</td>\n",
       "      <td>安信稳健增值混合A</td>\n",
       "      <td>AXWJZZHHA</td>\n",
       "      <td>1.2222</td>\n",
       "      <td>1.2222</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>001399</td>\n",
       "      <td>安信鑫安得利混合A</td>\n",
       "      <td>AXXADLHHA</td>\n",
       "      <td>1.2068</td>\n",
       "      <td>1.2068</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>003026</td>\n",
       "      <td>安信新价值混合A</td>\n",
       "      <td>AXXJZHHA</td>\n",
       "      <td>1.1981</td>\n",
       "      <td>1.1981</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>003027</td>\n",
       "      <td>安信新价值混合C</td>\n",
       "      <td>AXXJZHHC</td>\n",
       "      <td>1.1926</td>\n",
       "      <td>1.1926</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>001400</td>\n",
       "      <td>安信鑫安得利混合C</td>\n",
       "      <td>AXXADLHHC</td>\n",
       "      <td>1.1924</td>\n",
       "      <td>1.1924</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>750002</td>\n",
       "      <td>安信目标收益债券A</td>\n",
       "      <td>AXMBSYZQA</td>\n",
       "      <td>1.1890</td>\n",
       "      <td>1.3540</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>750005</td>\n",
       "      <td>安信平稳增长混合发起A</td>\n",
       "      <td>AXPWZZHHFQA</td>\n",
       "      <td>1.1774</td>\n",
       "      <td>1.6574</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>002035</td>\n",
       "      <td>安信平稳增长混合发起C</td>\n",
       "      <td>AXPWZZHHFQC</td>\n",
       "      <td>1.1752</td>\n",
       "      <td>1.6552</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>003261</td>\n",
       "      <td>安信沪深300增强发起式A</td>\n",
       "      <td>AXHS300ZQFQSA</td>\n",
       "      <td>1.1743</td>\n",
       "      <td>1.1743</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>003262</td>\n",
       "      <td>安信沪深300增强发起式C</td>\n",
       "      <td>AXHS300ZQFQSC</td>\n",
       "      <td>1.1675</td>\n",
       "      <td>1.1675</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>004249</td>\n",
       "      <td>安信中国制造2025混合</td>\n",
       "      <td>AXZGZZ2025HH</td>\n",
       "      <td>1.1660</td>\n",
       "      <td>1.1660</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>750003</td>\n",
       "      <td>安信目标收益债券C</td>\n",
       "      <td>AXMBSYZQC</td>\n",
       "      <td>1.1570</td>\n",
       "      <td>1.3220</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>167501</td>\n",
       "      <td>安信宝利债券(LOF)</td>\n",
       "      <td>AXBLZQLOF</td>\n",
       "      <td>1.1540</td>\n",
       "      <td>1.3550</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>000433</td>\n",
       "      <td>安信鑫发优选混合</td>\n",
       "      <td>AXXFYXHH</td>\n",
       "      <td>1.1320</td>\n",
       "      <td>1.1320</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>002770</td>\n",
       "      <td>安信新回报混合A</td>\n",
       "      <td>AXXHBHHA</td>\n",
       "      <td>1.0864</td>\n",
       "      <td>1.1364</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>002771</td>\n",
       "      <td>安信新回报混合C</td>\n",
       "      <td>AXXHBHHC</td>\n",
       "      <td>1.0818</td>\n",
       "      <td>1.1318</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>750001</td>\n",
       "      <td>安信灵活配置混合</td>\n",
       "      <td>AXLHPZHH</td>\n",
       "      <td>1.0790</td>\n",
       "      <td>1.6690</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>003638</td>\n",
       "      <td>安信永鑫增强债券C</td>\n",
       "      <td>AXYXZQZQC</td>\n",
       "      <td>1.0619</td>\n",
       "      <td>1.0619</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>003637</td>\n",
       "      <td>安信永鑫增强债券A</td>\n",
       "      <td>AXYXZQZQA</td>\n",
       "      <td>1.0595</td>\n",
       "      <td>1.0595</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>000310</td>\n",
       "      <td>安信永利信用A</td>\n",
       "      <td>AXYLXYA</td>\n",
       "      <td>1.05</td>\n",
       "      <td>1.36</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>003030</td>\n",
       "      <td>安信新目标混合A</td>\n",
       "      <td>AXXMBHHA</td>\n",
       "      <td>1.05</td>\n",
       "      <td>1.0670</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>安信基金</td>\n",
       "      <td>80163340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>161723</td>\n",
       "      <td>招商中证银行指数分级</td>\n",
       "      <td>ZSZZYHZSFJ</td>\n",
       "      <td>0.9450</td>\n",
       "      <td>1.0050</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>161718</td>\n",
       "      <td>招商沪深300高贝塔指数分级</td>\n",
       "      <td>ZSHS300GBTZSFJ</td>\n",
       "      <td>0.9210</td>\n",
       "      <td>1.1990</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>161720</td>\n",
       "      <td>招商中证全指证券公司指数分级</td>\n",
       "      <td>ZSZZQZZQGSZSFJ</td>\n",
       "      <td>0.9190</td>\n",
       "      <td>0.6390</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>217005</td>\n",
       "      <td>招商先锋</td>\n",
       "      <td>ZSXF</td>\n",
       "      <td>0.9178</td>\n",
       "      <td>2.8733</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>161719</td>\n",
       "      <td>招商可转债分级债券</td>\n",
       "      <td>ZSKZZFJZQ</td>\n",
       "      <td>0.8890</td>\n",
       "      <td>1.34</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>004784</td>\n",
       "      <td>招商稳健优选股票</td>\n",
       "      <td>ZSWJYXGP</td>\n",
       "      <td>0.8886</td>\n",
       "      <td>0.8886</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>001403</td>\n",
       "      <td>招商国企改革主题混合基金</td>\n",
       "      <td>ZSGQGGZTHHJJ</td>\n",
       "      <td>0.86</td>\n",
       "      <td>0.86</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>004195</td>\n",
       "      <td>招商中证1000指数增强C</td>\n",
       "      <td>ZSZZ1000ZSZQC</td>\n",
       "      <td>0.8393</td>\n",
       "      <td>0.8393</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>004194</td>\n",
       "      <td>招商中证1000指数增强A</td>\n",
       "      <td>ZSZZ1000ZSZQA</td>\n",
       "      <td>0.8343</td>\n",
       "      <td>0.8343</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>001628</td>\n",
       "      <td>招商体育文化休闲股票</td>\n",
       "      <td>ZSTYWHXXGP</td>\n",
       "      <td>0.8320</td>\n",
       "      <td>0.8320</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>003416</td>\n",
       "      <td>招商财经大数据股票</td>\n",
       "      <td>ZSCJDSJGP</td>\n",
       "      <td>0.8055</td>\n",
       "      <td>0.8055</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>001404</td>\n",
       "      <td>招商移动互联网产业股票基金</td>\n",
       "      <td>ZSYDHLWCYGPJJ</td>\n",
       "      <td>0.7620</td>\n",
       "      <td>0.7620</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>161721</td>\n",
       "      <td>招商沪深300地产等权重分级</td>\n",
       "      <td>ZSHS300DCDQZFJ</td>\n",
       "      <td>0.7430</td>\n",
       "      <td>1.3290</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>217001</td>\n",
       "      <td>招商安泰混合</td>\n",
       "      <td>ZSATHH</td>\n",
       "      <td>0.3533</td>\n",
       "      <td>3.7203</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>217015</td>\n",
       "      <td>招商全球资源</td>\n",
       "      <td>ZSQQZY</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>001774</td>\n",
       "      <td>招商丰庆混合C</td>\n",
       "      <td>ZSFQHHC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>003046</td>\n",
       "      <td>招商信用定开债人民币</td>\n",
       "      <td>ZSXYDKZRMB</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>002457</td>\n",
       "      <td>招商安元保本混合C</td>\n",
       "      <td>ZSAYBBHHC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>003047</td>\n",
       "      <td>招商信用定开债美元</td>\n",
       "      <td>ZSXYDKZMY</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>003443</td>\n",
       "      <td>招商招惠3个月定期开放债券C</td>\n",
       "      <td>ZSZH3GYDQKFZQC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>003570</td>\n",
       "      <td>招商招丰纯债C</td>\n",
       "      <td>ZSZFCZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>003572</td>\n",
       "      <td>招商招琪纯债C</td>\n",
       "      <td>ZSZQCZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>003864</td>\n",
       "      <td>招商招祥纯债C</td>\n",
       "      <td>ZSZXCZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>003449</td>\n",
       "      <td>招商招华纯债C</td>\n",
       "      <td>ZSZHCZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>161714</td>\n",
       "      <td>招商标普金砖四国指数</td>\n",
       "      <td>ZSBPJZSGZS</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>003441</td>\n",
       "      <td>招商招享纯债C</td>\n",
       "      <td>ZSZXCZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>003451</td>\n",
       "      <td>招商招信定开债C</td>\n",
       "      <td>ZSZXDKZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>003868</td>\n",
       "      <td>招商招景纯债C</td>\n",
       "      <td>ZSZJCZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>005595</td>\n",
       "      <td>招商添润3个月定开债C</td>\n",
       "      <td>ZSTR3GYDKZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>005649</td>\n",
       "      <td>招商添琪3个月定开债C</td>\n",
       "      <td>ZSTQ3GYDKZC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>招商基金</td>\n",
       "      <td>80036782</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6071 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    fundcode        fundname         pingyin     nav accu_nav        date  \\\n",
       "0     000577        安信价值精选股票        AXJZJXGP  2.8250   2.8250  2018-06-15   \n",
       "1     000974        安信消费医药股票        AXXFYYGP    1.54     1.54  2018-06-15   \n",
       "2     001287       安信优势增长混合A       AXYSZZHHA  1.5114   1.5114  2018-06-15   \n",
       "3     002036       安信优势增长混合C       AXYSZZHHC  1.5057   1.5057  2018-06-15   \n",
       "4     001583         安信新常态股票         AXXCTGP  1.3210   1.3210  2018-06-15   \n",
       "5     001185       安信动态策略混合A       AXDTCLHHA  1.2587   1.2587  2018-06-15   \n",
       "6     002029       安信动态策略混合C       AXDTCLHHC  1.2509   1.2509  2018-06-15   \n",
       "7     001338       安信稳健增值混合C       AXWJZZHHC  1.2394   1.2394  2018-06-15   \n",
       "8     004393    安信合作创新灵活配置混合    AXHZCXLHPZHH  1.2261   1.2261  2018-06-15   \n",
       "9     001316       安信稳健增值混合A       AXWJZZHHA  1.2222   1.2222  2018-06-15   \n",
       "10    001399       安信鑫安得利混合A       AXXADLHHA  1.2068   1.2068  2018-06-15   \n",
       "11    003026        安信新价值混合A        AXXJZHHA  1.1981   1.1981  2018-06-15   \n",
       "12    003027        安信新价值混合C        AXXJZHHC  1.1926   1.1926  2018-06-15   \n",
       "13    001400       安信鑫安得利混合C       AXXADLHHC  1.1924   1.1924  2018-06-15   \n",
       "14    750002       安信目标收益债券A       AXMBSYZQA  1.1890   1.3540  2018-06-15   \n",
       "15    750005     安信平稳增长混合发起A     AXPWZZHHFQA  1.1774   1.6574  2018-06-15   \n",
       "16    002035     安信平稳增长混合发起C     AXPWZZHHFQC  1.1752   1.6552  2018-06-15   \n",
       "17    003261   安信沪深300增强发起式A   AXHS300ZQFQSA  1.1743   1.1743  2018-06-15   \n",
       "18    003262   安信沪深300增强发起式C   AXHS300ZQFQSC  1.1675   1.1675  2018-06-15   \n",
       "19    004249    安信中国制造2025混合    AXZGZZ2025HH  1.1660   1.1660  2018-06-15   \n",
       "20    750003       安信目标收益债券C       AXMBSYZQC  1.1570   1.3220  2018-06-15   \n",
       "21    167501     安信宝利债券(LOF)       AXBLZQLOF  1.1540   1.3550  2018-06-15   \n",
       "22    000433        安信鑫发优选混合        AXXFYXHH  1.1320   1.1320  2018-06-15   \n",
       "23    002770        安信新回报混合A        AXXHBHHA  1.0864   1.1364  2018-06-15   \n",
       "24    002771        安信新回报混合C        AXXHBHHC  1.0818   1.1318  2018-06-15   \n",
       "25    750001        安信灵活配置混合        AXLHPZHH  1.0790   1.6690  2018-06-15   \n",
       "26    003638       安信永鑫增强债券C       AXYXZQZQC  1.0619   1.0619  2018-06-15   \n",
       "27    003637       安信永鑫增强债券A       AXYXZQZQA  1.0595   1.0595  2018-06-15   \n",
       "28    000310         安信永利信用A         AXYLXYA    1.05     1.36  2018-06-15   \n",
       "29    003030        安信新目标混合A        AXXMBHHA    1.05   1.0670  2018-06-15   \n",
       "..       ...             ...             ...     ...      ...         ...   \n",
       "150   161723      招商中证银行指数分级      ZSZZYHZSFJ  0.9450   1.0050  2018-06-15   \n",
       "151   161718  招商沪深300高贝塔指数分级  ZSHS300GBTZSFJ  0.9210   1.1990  2018-06-15   \n",
       "152   161720  招商中证全指证券公司指数分级  ZSZZQZZQGSZSFJ  0.9190   0.6390  2018-06-15   \n",
       "153   217005            招商先锋            ZSXF  0.9178   2.8733  2018-06-15   \n",
       "154   161719       招商可转债分级债券       ZSKZZFJZQ  0.8890     1.34  2018-06-15   \n",
       "155   004784        招商稳健优选股票        ZSWJYXGP  0.8886   0.8886  2018-06-15   \n",
       "156   001403    招商国企改革主题混合基金    ZSGQGGZTHHJJ    0.86     0.86  2018-06-15   \n",
       "157   004195   招商中证1000指数增强C   ZSZZ1000ZSZQC  0.8393   0.8393  2018-06-15   \n",
       "158   004194   招商中证1000指数增强A   ZSZZ1000ZSZQA  0.8343   0.8343  2018-06-15   \n",
       "159   001628      招商体育文化休闲股票      ZSTYWHXXGP  0.8320   0.8320  2018-06-15   \n",
       "160   003416       招商财经大数据股票       ZSCJDSJGP  0.8055   0.8055  2018-06-15   \n",
       "161   001404   招商移动互联网产业股票基金   ZSYDHLWCYGPJJ  0.7620   0.7620  2018-06-15   \n",
       "162   161721  招商沪深300地产等权重分级  ZSHS300DCDQZFJ  0.7430   1.3290  2018-06-15   \n",
       "163   217001          招商安泰混合          ZSATHH  0.3533   3.7203  2018-06-15   \n",
       "164   217015          招商全球资源          ZSQQZY                   2018-06-15   \n",
       "165   001774         招商丰庆混合C         ZSFQHHC                   2018-06-15   \n",
       "166   003046      招商信用定开债人民币      ZSXYDKZRMB                   2018-06-15   \n",
       "167   002457       招商安元保本混合C       ZSAYBBHHC                   2018-06-15   \n",
       "168   003047       招商信用定开债美元       ZSXYDKZMY                   2018-06-15   \n",
       "169   003443  招商招惠3个月定期开放债券C  ZSZH3GYDQKFZQC                   2018-06-15   \n",
       "170   003570         招商招丰纯债C         ZSZFCZC                   2018-06-15   \n",
       "171   003572         招商招琪纯债C         ZSZQCZC                   2018-06-15   \n",
       "172   003864         招商招祥纯债C         ZSZXCZC                   2018-06-15   \n",
       "173   003449         招商招华纯债C         ZSZHCZC                   2018-06-15   \n",
       "174   161714      招商标普金砖四国指数      ZSBPJZSGZS                   2018-06-15   \n",
       "175   003441         招商招享纯债C         ZSZXCZC                   2018-06-15   \n",
       "176   003451        招商招信定开债C        ZSZXDKZC                   2018-06-15   \n",
       "177   003868         招商招景纯债C         ZSZJCZC                   2018-06-15   \n",
       "178   005595     招商添润3个月定开债C     ZSTR3GYDKZC                   2018-06-15   \n",
       "179   005649     招商添琪3个月定开债C     ZSTQ3GYDKZC                   2018-06-15   \n",
       "\n",
       "    companyname companyid  \n",
       "0          安信基金  80163340  \n",
       "1          安信基金  80163340  \n",
       "2          安信基金  80163340  \n",
       "3          安信基金  80163340  \n",
       "4          安信基金  80163340  \n",
       "5          安信基金  80163340  \n",
       "6          安信基金  80163340  \n",
       "7          安信基金  80163340  \n",
       "8          安信基金  80163340  \n",
       "9          安信基金  80163340  \n",
       "10         安信基金  80163340  \n",
       "11         安信基金  80163340  \n",
       "12         安信基金  80163340  \n",
       "13         安信基金  80163340  \n",
       "14         安信基金  80163340  \n",
       "15         安信基金  80163340  \n",
       "16         安信基金  80163340  \n",
       "17         安信基金  80163340  \n",
       "18         安信基金  80163340  \n",
       "19         安信基金  80163340  \n",
       "20         安信基金  80163340  \n",
       "21         安信基金  80163340  \n",
       "22         安信基金  80163340  \n",
       "23         安信基金  80163340  \n",
       "24         安信基金  80163340  \n",
       "25         安信基金  80163340  \n",
       "26         安信基金  80163340  \n",
       "27         安信基金  80163340  \n",
       "28         安信基金  80163340  \n",
       "29         安信基金  80163340  \n",
       "..          ...       ...  \n",
       "150        招商基金  80036782  \n",
       "151        招商基金  80036782  \n",
       "152        招商基金  80036782  \n",
       "153        招商基金  80036782  \n",
       "154        招商基金  80036782  \n",
       "155        招商基金  80036782  \n",
       "156        招商基金  80036782  \n",
       "157        招商基金  80036782  \n",
       "158        招商基金  80036782  \n",
       "159        招商基金  80036782  \n",
       "160        招商基金  80036782  \n",
       "161        招商基金  80036782  \n",
       "162        招商基金  80036782  \n",
       "163        招商基金  80036782  \n",
       "164        招商基金  80036782  \n",
       "165        招商基金  80036782  \n",
       "166        招商基金  80036782  \n",
       "167        招商基金  80036782  \n",
       "168        招商基金  80036782  \n",
       "169        招商基金  80036782  \n",
       "170        招商基金  80036782  \n",
       "171        招商基金  80036782  \n",
       "172        招商基金  80036782  \n",
       "173        招商基金  80036782  \n",
       "174        招商基金  80036782  \n",
       "175        招商基金  80036782  \n",
       "176        招商基金  80036782  \n",
       "177        招商基金  80036782  \n",
       "178        招商基金  80036782  \n",
       "179        招商基金  80036782  \n",
       "\n",
       "[6071 rows x 8 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 获取全部的基金列表（这个运行会很慢）\n",
    "df, msg = fund.get_fund_list()\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
